<?php

class teammodel extends model{
public function teamlist($id){
$sql="select player from player where tid =$id";
return $this->db->query($sql);
} 


public function countlist($id){
$sql_c="select count(*) as a from player where tid=$id";
return $this->db->query($sql_c);
}

public function playerlist($id){
$sql_t="select team from team where id=$id";
return $this->db->query($sql_t);
}
} 
 

// $id=$_GET['id'];
// $config = include_once('config.php');
// include_once('mysql.class.php');
// $db = new MySqlDB($config);
// $sql="select player from player where tid =$id";
// $sql_c="select count(*) as a from player where tid=$id";
// $sql_t="select team from team where id=$id";
// $res=$db->query($sql);
// $res_c=$db->query($sql_c);
// $res_t=$db->query($sql_t);
// var_dump($res);
// var_dump($res_c);
// var_dump($res_t);
 ?>